Create the Column Charts Part 2 11
Step 8.3 – Create the Age Group Chart
In the FactTable create the measure Age Group
Age Group = IF((FactTable[ShootersAge])=0,"Unknown",
VAR AgeStart =
ROUNDDOWN ( FactTable[ShootersAge], -1 )
VAR DecadeEnd = AgeStart + 10
RETURN
AgeStart & "'s")
Proceed to copy the Race chart and paste it.
In the Shared Axis, replace the Shooters_Race column with the Age Group column.
Sort the chart by Age Group ascending.
Change the size and coordinates.
Change the title to Age Group.
Step 8.4 – Age Group Tooltip
Create a duplicate of the Race TP Page.
Rename It to Age TP.
Just like before, replace the Shooters_Race column with the Age Group column in the field Legend for both maps.
Also do the same changes for the 1st Card.
The Age Group tooltip should look like this.
Go back to the dashboard.
Activate the Tooltip option for the Age Group visualization and select the Age TP page.
Step 8.5 – Create the Weapon Type Chart
Select the Age Group Chart.
Copy it and paste it.
Remove from the shared axis the Age Group column and add the Weapon column from the DimWeapon Table.
Delete the current column values and add the measure .Total Shootings.
Change the title to Weapon Type
Change the name of the column value
Change the data label and data colors to the ones used in the previous charts.
Change the size and the position of the chart.
Step 8.6 – Weapon Type Tooltip
To create this tooltip, just repeat step 8.4. This time replace the columns with the Weapon column.
Step 8.7 – Date Chart
Create a Time Hierarchy.
Click on the ellipsis of the column decade.
Select New Hierarchy.
Go to the next column to be added to the hierarchy. In this case the column Year. Click on the ellipsis.
Hover over the option Add to hierarchy.
Select the hierarchy recently created.
Repeat the steps with the columns MonthName and DayName.
Rename the hierarchy to Time Hierarchy.
Select the weapon Type Chart.
Copy and Paste it.
Make it bigger.
Replace the Shared axis field. Delete Weapon and add Time Hierarchy.
Change the title to Date.
Go to Year hierarchy level.
Go to the Analytics tab.
Add a trend line.
Change the size and position of the chart to match the following picture.
Step 8.8 – Date Tooltip
To create this tooltip, just repeat step 8.6 and make the following changes:
Remove Weapon from the Legend field and leave it blank for both maps.
Delete the 1st text card and leave the other 3 cards.
Apply the following sizes and coordinates to the card visualizations.
At this point the Dashboard should look like this: